/**
 * Software License, Version 1.0
 * 
 * Copyright 2003 The Trustees of Indiana University.  All rights reserved.
 * 
 *
 *Redistribution and use in source and binary forms, with or without 
 *modification, are permitted provided that the following conditions are met:
 *
 *1) All redistributions of source code must retain the above copyright notice,
 * the list of authors in the original source code, this list of conditions and
 * the disclaimer listed in this license;
 *2) All redistributions in binary form must reproduce the above copyright 
 * notice, this list of conditions and the disclaimer listed in this license in
 * the documentation and/or other materials provided with the distribution;
 *3) Any documentation included with all redistributions must include the 
 * following acknowledgement:
 *
 *"This product includes software developed by the Community Grids Lab. For 
 * further information contact the Community Grids Lab at 
 * http://communitygrids.iu.edu/."
 *
 * Alternatively, this acknowledgement may appear in the software itself, and 
 * wherever such third-party acknowledgments normally appear.
 * 
 *4) The name Indiana University or Community Grids Lab or NaradaBrokering, 
 * shall not be used to endorse or promote products derived from this software 
 * without prior written permission from Indiana University.  For written 
 * permission, please contact the Advanced Research and Technology Institute 
 * ("ARTI") at 351 West 10th Street, Indianapolis, Indiana 46202.
 *5) Products derived from this software may not be called NaradaBrokering, 
 * nor may Indiana University or Community Grids Lab or NaradaBrokering appear
 * in their name, without prior written permission of ARTI.
 * 
 *
 * Indiana University provides no reassurances that the source code provided 
 * does not infringe the patent or any other intellectual property rights of 
 * any other entity.  Indiana University disclaims any liability to any 
 * recipient for claims brought by any other entity based on infringement of 
 * intellectual property rights or otherwise.  
 *
 *LICENSEE UNDERSTANDS THAT SOFTWARE IS PROVIDED "AS IS" FOR WHICH NO 
 *WARRANTIES AS TO CAPABILITIES OR ACCURACY ARE MADE. INDIANA UNIVERSITY GIVES
 *NO WARRANTIES AND MAKES NO REPRESENTATION THAT SOFTWARE IS FREE OF 
 *INFRINGEMENT OF THIRD PARTY PATENT, COPYRIGHT, OR OTHER PROPRIETARY RIGHTS. 
 *INDIANA UNIVERSITY MAKES NO WARRANTIES THAT SOFTWARE IS FREE FROM "BUGS", 
 *"VIRUSES", "TROJAN HORSES", "TRAP DOORS", "WORMS", OR OTHER HARMFUL CODE.  
 *LICENSEE ASSUMES THE ENTIRE RISK AS TO THE PERFORMANCE OF SOFTWARE AND/OR 
 *ASSOCIATED MATERIALS, AND TO THE PERFORMANCE AND VALIDITY OF INFORMATION 
 *GENERATED USING SOFTWARE.
 */
package cgl.narada.wsinfra.wsrm.storage.impl;


import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Vector;

import cgl.narada.wsinfra.wsrm.WsrmSequencePolicies;
import cgl.narada.wsinfra.wsrm.impl.WsrmSequencePoliciesImpl;
import cgl.narada.wsinfra.wsrm.storage.WsrmPolicyStorageOperations;
import cgl.narada.wsinfra.wsrm.storage.WsrmStorageEventsFactory;
import cgl.narada.wsinfra.wsrm.storage.WsrmStorageException;

/** This is the interface used to check if sequence policies based on
    sequence prefixes have been registered. If there is a match with
    the newly created sequence, and this sequence DOES NOT have a sequence
    policies info, we use the default policies that have been previously
    registered.
    @author Beytullah Yildiz
    $Date: 2005/07/29 22:41:31 $
    $Revision: 1.3 $
 */

public class WsrmPolicyStorageOperationsImpl
    implements WsrmPolicyStorageOperations {
  private WsrmQueryHandler wsrmQueryHandler;
  private String moduleName = "WsrmPolicyStorageOperationsImpl: ";

  public WsrmPolicyStorageOperationsImpl() {}

  public WsrmPolicyStorageOperationsImpl(Connection connection) {

    wsrmQueryHandler = new WsrmQueryHandler(connection);
  }

  /** Stores a WsrmSequencePolicies document based on the specified prefix */
  public void storePolicyInformation(String prefix,
                                     WsrmSequencePolicies wsrmSequencePolicies) throws
      WsrmStorageException {

    String query = "insert into  policystorageoperation"
          + " values('" + prefix +"', ? )";

      PreparedStatement pstmt =
         wsrmQueryHandler.getPreparedStatement(query);
     try {
       pstmt.setBytes(1, wsrmSequencePolicies.getBytes());
       pstmt.executeUpdate();
       pstmt.close();

     }
     catch (SQLException ex) {
       throw new WsrmStorageException(moduleName +
                                      "storeCreatedSequence exception ["
                                      + query + "] " + ex.toString());
     }

     System.out.println(moduleName + "WSRM Policy which has prefix <" +
                        prefix + " is stored");



  }

  /** Retrieve the list of sequence prefixes */
  public String[] getSequencePrefixes() throws WsrmStorageException {

   String query =
       "select prefix from policystorageoperation";

   PreparedStatement preparedStatement =
       wsrmQueryHandler.getPreparedStatement(query);
   ResultSet resultSet = wsrmQueryHandler.getResultSet(preparedStatement);

   String []prefixes = wsrmQueryHandler.getStringArray(resultSet);
   wsrmQueryHandler.closeResultSet(resultSet);
   wsrmQueryHandler.closePreparedStatement(preparedStatement);

   return prefixes;

  }

  /** Retrieves a WsrmSequencePolicies associated with the specified
      prefix */
  public WsrmSequencePolicies getWsrmSequencePolicies(String prefix) throws
      WsrmStorageException {
    String  query =
       "select sequencePolicy from policystorageoperation where prefix='"
       + prefix + "'";

   PreparedStatement preparedStatement =
       wsrmQueryHandler.getPreparedStatement(query);
   ResultSet resultSet = wsrmQueryHandler.getResultSet(preparedStatement);

   Vector byteArrayVector = getResultSetInVecotorForPolicy(resultSet);

   if (byteArrayVector.size() <= 0) {
     throw new WsrmStorageException(moduleName +
         " getWsrmSequencePolicies exception [" + query + "] " +
         "prefix does not exist");

   }
   byte[] byteArray = (byte[]) byteArrayVector.remove(0);

   WsrmStorageEventsFactory wsrmStorageEventsFactory =
       WsrmStorageEventsFactory.getInstance();

   WsrmSequencePoliciesImpl wsrmSequencePolicies=
       new WsrmSequencePoliciesImpl(byteArray);


   wsrmQueryHandler.closeResultSet(resultSet);
   wsrmQueryHandler.closePreparedStatement(preparedStatement);

   return wsrmSequencePolicies;

  }

  private Vector getResultSetInVecotorForPolicy(ResultSet resultSet) throws
     WsrmStorageException {
   Vector resultVector = new Vector();

   try {
     while (resultSet.next()) {
       resultVector.add(resultSet.getBytes(1));
     }
   }
   catch (SQLException ex) {
     throw new WsrmStorageException(moduleName +
         " getResultSetInVecotorForSequenceInfo exception " + ex.toString());

   }

   return resultVector;
 }

}
